package com.ctshk.rpc.season.mapper;

import com.ctshk.rpc.season.base.CustomBaseMapper;
import com.ctshk.rpc.season.entity.SeasonFixedDepartDate;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

/**
 * @author 杨林
 * @version 1.0
 * @date 2021/4/12 17:10
 */
public interface SeasonFixedDepartDateMapper extends CustomBaseMapper<SeasonFixedDepartDate> {


    @Select("<script> select depart_date from t_season_fixed_depart_date where is_deleted=0  \n" +
            " and product_id=#{productId} AND  depart_date  between #{startDate}  and #{endDate}  \n" +
            "</script>"
    )
    List<LocalDate> getYesDepartDate(@Param("productId") Long productId, @Param("startDate") LocalDate startDate, @Param("endDate") LocalDate endDate);
}
